<!DOCTYPE html>



  


<html class="theme-next mist use-motion" lang="zh-Hans">
<head>
  <meta charset="UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1"/>
<meta name="theme-color" content="#222">









<meta http-equiv="Cache-Control" content="no-transform" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
















  
  
  <link href="/lib/fancybox/source/jquery.fancybox.css?v=2.1.5" rel="stylesheet" type="text/css" />







<link href="/lib/font-awesome/css/font-awesome.min.css?v=4.6.2" rel="stylesheet" type="text/css" />

<link href="/css/main.css?v=5.1.4" rel="stylesheet" type="text/css" />


  <link rel="apple-touch-icon" sizes="180x180" href="/images/apple-touch-icon-next.png?v=5.1.4">


  <link rel="icon" type="image/png" sizes="32x32" href="/images/favicon-32x32-next.png?v=5.1.4">


  <link rel="icon" type="image/png" sizes="16x16" href="/images/favicon-16x16-next.png?v=5.1.4">


  <link rel="mask-icon" href="/images/logo.svg?v=5.1.4" color="#222">





  <meta name="keywords" content="Hexo, NexT" />










<meta name="description" content="java-jdbc驱动使用详解（三）单机分库分表下的性能测试上一篇进行过测试，批处理和事务提交结合，可以显著的提升数据库增删改操作的性能，但是有一个问题——在多表和多数据库情况下使用多线程编程性能会提升多少。为了解决这个问题进行了如下的测试 测试代码123456789101112131415161718192021222324252627282930313233343536373839404142">
<meta property="og:type" content="article">
<meta property="og:title" content="kyssion-blog">
<meta property="og:url" content="http://yoursite.com/2018/10/09/jdbc驱动使用详解（三）单机分库分表下的性能测试/index.html">
<meta property="og:site_name" content="kyssion-blog">
<meta property="og:description" content="java-jdbc驱动使用详解（三）单机分库分表下的性能测试上一篇进行过测试，批处理和事务提交结合，可以显著的提升数据库增删改操作的性能，但是有一个问题——在多表和多数据库情况下使用多线程编程性能会提升多少。为了解决这个问题进行了如下的测试 测试代码123456789101112131415161718192021222324252627282930313233343536373839404142">
<meta property="og:locale" content="zh-Hans">
<meta property="og:updated_time" content="2018-10-09T07:22:37.337Z">
<meta name="twitter:card" content="summary">
<meta name="twitter:title" content="kyssion-blog">
<meta name="twitter:description" content="java-jdbc驱动使用详解（三）单机分库分表下的性能测试上一篇进行过测试，批处理和事务提交结合，可以显著的提升数据库增删改操作的性能，但是有一个问题——在多表和多数据库情况下使用多线程编程性能会提升多少。为了解决这个问题进行了如下的测试 测试代码123456789101112131415161718192021222324252627282930313233343536373839404142">



<script type="text/javascript" id="hexo.configurations">
  var NexT = window.NexT || {};
  var CONFIG = {
    root: '/',
    scheme: 'Mist',
    version: '5.1.4',
    sidebar: {"position":"left","display":"post","offset":12,"b2t":false,"scrollpercent":false,"onmobile":false},
    fancybox: true,
    tabs: true,
    motion: {"enable":true,"async":false,"transition":{"post_block":"fadeIn","post_header":"slideDownIn","post_body":"slideDownIn","coll_header":"slideLeftIn","sidebar":"slideUpIn"}},
    duoshuo: {
      userId: '0',
      author: '博主'
    },
    algolia: {
      applicationID: '',
      apiKey: '',
      indexName: '',
      hits: {"per_page":10},
      labels: {"input_placeholder":"Search for Posts","hits_empty":"We didn't find any results for the search: ${query}","hits_stats":"${hits} results found in ${time} ms"}
    }
  };
</script>



  <link rel="canonical" href="http://yoursite.com/2018/10/09/jdbc驱动使用详解（三）单机分库分表下的性能测试/"/>





  <title> | kyssion-blog</title>
  








</head>

<body itemscope itemtype="http://schema.org/WebPage" lang="zh-Hans">

  
  
    
  

  <div class="container sidebar-position-left page-post-detail">
    <div class="headband"></div>

    <header id="header" class="header" itemscope itemtype="http://schema.org/WPHeader">
      <div class="header-inner"><div class="site-brand-wrapper">
  <div class="site-meta ">
    

    <div class="custom-logo-site-title">
      <a href="/"  class="brand" rel="start">
        <span class="logo-line-before"><i></i></span>
        <span class="site-title">kyssion-blog</span>
        <span class="logo-line-after"><i></i></span>
      </a>
    </div>
      
        <p class="site-subtitle"></p>
      
  </div>

  <div class="site-nav-toggle">
    <button>
      <span class="btn-bar"></span>
      <span class="btn-bar"></span>
      <span class="btn-bar"></span>
    </button>
  </div>
</div>

<nav class="site-nav">
  

  
    <ul id="menu" class="menu">
      
        
        <li class="menu-item menu-item-home">
          <a href="/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-home"></i> <br />
            
            首页
          </a>
        </li>
      
        
        <li class="menu-item menu-item-about">
          <a href="/about/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-user"></i> <br />
            
            关于
          </a>
        </li>
      
        
        <li class="menu-item menu-item-tags">
          <a href="/tags/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-tags"></i> <br />
            
            标签
          </a>
        </li>
      
        
        <li class="menu-item menu-item-categories">
          <a href="/categories/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-th"></i> <br />
            
            分类
          </a>
        </li>
      
        
        <li class="menu-item menu-item-archives">
          <a href="/archives/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-archive"></i> <br />
            
            归档
          </a>
        </li>
      
        
        <li class="menu-item menu-item-schedule">
          <a href="/schedule/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-calendar"></i> <br />
            
            日程表
          </a>
        </li>
      
        
        <li class="menu-item menu-item-sitemap">
          <a href="/sitemap.xml" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-sitemap"></i> <br />
            
            站点地图
          </a>
        </li>
      
        
        <li class="menu-item menu-item-commonweal">
          <a href="/404/" rel="section">
            
              <i class="menu-item-icon fa fa-fw fa-heartbeat"></i> <br />
            
            公益404
          </a>
        </li>
      

      
    </ul>
  

  
</nav>



 </div>
    </header>

    <main id="main" class="main">
      <div class="main-inner">
        <div class="content-wrap">
          <div id="content" class="content">
            

  <div id="posts" class="posts-expand">
    

  

  
  
  

  <article class="post post-type-normal" itemscope itemtype="http://schema.org/Article">
  
  
  
  <div class="post-block">
    <link itemprop="mainEntityOfPage" href="http://yoursite.com/2018/10/09/jdbc驱动使用详解（三）单机分库分表下的性能测试/">

    <span hidden itemprop="author" itemscope itemtype="http://schema.org/Person">
      <meta itemprop="name" content="kyssion">
      <meta itemprop="description" content="">
      <meta itemprop="image" content="/images/avatar.gif">
    </span>

    <span hidden itemprop="publisher" itemscope itemtype="http://schema.org/Organization">
      <meta itemprop="name" content="kyssion-blog">
    </span>

    
      <header class="post-header">

        
        
          <h1 class="post-title" itemprop="name headline"></h1>
        

        <div class="post-meta">
          <span class="post-time">
            
              <span class="post-meta-item-icon">
                <i class="fa fa-calendar-o"></i>
              </span>
              
                <span class="post-meta-item-text">发表于</span>
              
              <time title="创建于" itemprop="dateCreated datePublished" datetime="2018-10-09T15:22:37+08:00">
                2018-10-09
              </time>
            

            

            
          </span>

          

          
            
          

          
          

          

          

          

        </div>
      </header>
    

    
    
    
    <div class="post-body" itemprop="articleBody">

      
      

      
        <h2 id="java-jdbc驱动使用详解（三）单机分库分表下的性能测试"><a href="#java-jdbc驱动使用详解（三）单机分库分表下的性能测试" class="headerlink" title="java-jdbc驱动使用详解（三）单机分库分表下的性能测试"></a>java-jdbc驱动使用详解（三）单机分库分表下的性能测试</h2><p>上一篇进行过测试，批处理和事务提交结合，可以显著的提升数据库增删改操作的性能，但是有一个问题——在多表和多数据库情况下使用多线程编程性能会提升多少。为了解决这个问题进行了如下的测试</p>
<h3 id="测试代码"><a href="#测试代码" class="headerlink" title="测试代码"></a>测试代码</h3><figure class="highlight java"><table><tr><td class="gutter"><pre><span class="line">1</span><br><span class="line">2</span><br><span class="line">3</span><br><span class="line">4</span><br><span class="line">5</span><br><span class="line">6</span><br><span class="line">7</span><br><span class="line">8</span><br><span class="line">9</span><br><span class="line">10</span><br><span class="line">11</span><br><span class="line">12</span><br><span class="line">13</span><br><span class="line">14</span><br><span class="line">15</span><br><span class="line">16</span><br><span class="line">17</span><br><span class="line">18</span><br><span class="line">19</span><br><span class="line">20</span><br><span class="line">21</span><br><span class="line">22</span><br><span class="line">23</span><br><span class="line">24</span><br><span class="line">25</span><br><span class="line">26</span><br><span class="line">27</span><br><span class="line">28</span><br><span class="line">29</span><br><span class="line">30</span><br><span class="line">31</span><br><span class="line">32</span><br><span class="line">33</span><br><span class="line">34</span><br><span class="line">35</span><br><span class="line">36</span><br><span class="line">37</span><br><span class="line">38</span><br><span class="line">39</span><br><span class="line">40</span><br><span class="line">41</span><br><span class="line">42</span><br><span class="line">43</span><br><span class="line">44</span><br><span class="line">45</span><br><span class="line">46</span><br><span class="line">47</span><br><span class="line">48</span><br><span class="line">49</span><br><span class="line">50</span><br><span class="line">51</span><br><span class="line">52</span><br><span class="line">53</span><br><span class="line">54</span><br><span class="line">55</span><br><span class="line">56</span><br><span class="line">57</span><br><span class="line">58</span><br><span class="line">59</span><br><span class="line">60</span><br><span class="line">61</span><br><span class="line">62</span><br><span class="line">63</span><br><span class="line">64</span><br><span class="line">65</span><br><span class="line">66</span><br><span class="line">67</span><br><span class="line">68</span><br><span class="line">69</span><br><span class="line">70</span><br><span class="line">71</span><br><span class="line">72</span><br><span class="line">73</span><br><span class="line">74</span><br><span class="line">75</span><br><span class="line">76</span><br><span class="line">77</span><br><span class="line">78</span><br><span class="line">79</span><br><span class="line">80</span><br><span class="line">81</span><br><span class="line">82</span><br><span class="line">83</span><br><span class="line">84</span><br><span class="line">85</span><br><span class="line">86</span><br><span class="line">87</span><br><span class="line">88</span><br><span class="line">89</span><br><span class="line">90</span><br><span class="line">91</span><br><span class="line">92</span><br><span class="line">93</span><br><span class="line">94</span><br><span class="line">95</span><br><span class="line">96</span><br><span class="line">97</span><br><span class="line">98</span><br><span class="line">99</span><br><span class="line">100</span><br><span class="line">101</span><br><span class="line">102</span><br><span class="line">103</span><br><span class="line">104</span><br><span class="line">105</span><br><span class="line">106</span><br><span class="line">107</span><br><span class="line">108</span><br><span class="line">109</span><br><span class="line">110</span><br><span class="line">111</span><br><span class="line">112</span><br><span class="line">113</span><br><span class="line">114</span><br><span class="line">115</span><br><span class="line">116</span><br><span class="line">117</span><br><span class="line">118</span><br><span class="line">119</span><br><span class="line">120</span><br><span class="line">121</span><br><span class="line">122</span><br><span class="line">123</span><br><span class="line">124</span><br><span class="line">125</span><br><span class="line">126</span><br><span class="line">127</span><br><span class="line">128</span><br><span class="line">129</span><br><span class="line">130</span><br><span class="line">131</span><br><span class="line">132</span><br><span class="line">133</span><br><span class="line">134</span><br><span class="line">135</span><br><span class="line">136</span><br><span class="line">137</span><br><span class="line">138</span><br><span class="line">139</span><br><span class="line">140</span><br><span class="line">141</span><br><span class="line">142</span><br><span class="line">143</span><br><span class="line">144</span><br><span class="line">145</span><br><span class="line">146</span><br><span class="line">147</span><br><span class="line">148</span><br><span class="line">149</span><br><span class="line">150</span><br><span class="line">151</span><br><span class="line">152</span><br><span class="line">153</span><br><span class="line">154</span><br><span class="line">155</span><br><span class="line">156</span><br><span class="line">157</span><br><span class="line">158</span><br><span class="line">159</span><br><span class="line">160</span><br><span class="line">161</span><br><span class="line">162</span><br><span class="line">163</span><br><span class="line">164</span><br><span class="line">165</span><br><span class="line">166</span><br><span class="line">167</span><br><span class="line">168</span><br><span class="line">169</span><br><span class="line">170</span><br><span class="line">171</span><br><span class="line">172</span><br><span class="line">173</span><br><span class="line">174</span><br><span class="line">175</span><br><span class="line">176</span><br><span class="line">177</span><br><span class="line">178</span><br><span class="line">179</span><br><span class="line">180</span><br><span class="line">181</span><br><span class="line">182</span><br><span class="line">183</span><br><span class="line">184</span><br><span class="line">185</span><br><span class="line">186</span><br><span class="line">187</span><br><span class="line">188</span><br><span class="line">189</span><br><span class="line">190</span><br><span class="line">191</span><br><span class="line">192</span><br><span class="line">193</span><br><span class="line">194</span><br><span class="line">195</span><br><span class="line">196</span><br><span class="line">197</span><br><span class="line">198</span><br><span class="line">199</span><br><span class="line">200</span><br><span class="line">201</span><br><span class="line">202</span><br><span class="line">203</span><br><span class="line">204</span><br><span class="line">205</span><br><span class="line">206</span><br><span class="line">207</span><br><span class="line">208</span><br><span class="line">209</span><br><span class="line">210</span><br><span class="line">211</span><br><span class="line">212</span><br><span class="line">213</span><br><span class="line">214</span><br><span class="line">215</span><br><span class="line">216</span><br><span class="line">217</span><br><span class="line">218</span><br><span class="line">219</span><br><span class="line">220</span><br><span class="line">221</span><br><span class="line">222</span><br><span class="line">223</span><br><span class="line">224</span><br><span class="line">225</span><br><span class="line">226</span><br><span class="line">227</span><br><span class="line">228</span><br><span class="line">229</span><br><span class="line">230</span><br><span class="line">231</span><br><span class="line">232</span><br><span class="line">233</span><br><span class="line">234</span><br><span class="line">235</span><br><span class="line">236</span><br><span class="line">237</span><br><span class="line">238</span><br><span class="line">239</span><br><span class="line">240</span><br><span class="line">241</span><br><span class="line">242</span><br><span class="line">243</span><br><span class="line">244</span><br><span class="line">245</span><br><span class="line">246</span><br><span class="line">247</span><br><span class="line">248</span><br><span class="line">249</span><br><span class="line">250</span><br><span class="line">251</span><br><span class="line">252</span><br><span class="line">253</span><br><span class="line">254</span><br><span class="line">255</span><br><span class="line">256</span><br><span class="line">257</span><br><span class="line">258</span><br><span class="line">259</span><br><span class="line">260</span><br><span class="line">261</span><br><span class="line">262</span><br><span class="line">263</span><br><span class="line">264</span><br><span class="line">265</span><br><span class="line">266</span><br><span class="line">267</span><br><span class="line">268</span><br><span class="line">269</span><br><span class="line">270</span><br><span class="line">271</span><br><span class="line">272</span><br><span class="line">273</span><br><span class="line">274</span><br><span class="line">275</span><br><span class="line">276</span><br><span class="line">277</span><br><span class="line">278</span><br><span class="line">279</span><br><span class="line">280</span><br><span class="line">281</span><br><span class="line">282</span><br><span class="line">283</span><br><span class="line">284</span><br><span class="line">285</span><br><span class="line">286</span><br><span class="line">287</span><br><span class="line">288</span><br><span class="line">289</span><br><span class="line">290</span><br><span class="line">291</span><br><span class="line">292</span><br><span class="line">293</span><br><span class="line">294</span><br><span class="line">295</span><br><span class="line">296</span><br><span class="line">297</span><br><span class="line">298</span><br><span class="line">299</span><br><span class="line">300</span><br><span class="line">301</span><br><span class="line">302</span><br><span class="line">303</span><br><span class="line">304</span><br><span class="line">305</span><br><span class="line">306</span><br><span class="line">307</span><br><span class="line">308</span><br><span class="line">309</span><br><span class="line">310</span><br><span class="line">311</span><br><span class="line">312</span><br><span class="line">313</span><br><span class="line">314</span><br><span class="line">315</span><br><span class="line">316</span><br><span class="line">317</span><br><span class="line">318</span><br><span class="line">319</span><br><span class="line">320</span><br><span class="line">321</span><br><span class="line">322</span><br><span class="line">323</span><br><span class="line">324</span><br><span class="line">325</span><br><span class="line">326</span><br><span class="line">327</span><br><span class="line">328</span><br><span class="line">329</span><br><span class="line">330</span><br><span class="line">331</span><br><span class="line">332</span><br><span class="line">333</span><br><span class="line">334</span><br><span class="line">335</span><br><span class="line">336</span><br><span class="line">337</span><br><span class="line">338</span><br><span class="line">339</span><br><span class="line">340</span><br><span class="line">341</span><br><span class="line">342</span><br><span class="line">343</span><br><span class="line">344</span><br><span class="line">345</span><br><span class="line">346</span><br><span class="line">347</span><br><span class="line">348</span><br><span class="line">349</span><br><span class="line">350</span><br><span class="line">351</span><br><span class="line">352</span><br><span class="line">353</span><br><span class="line">354</span><br><span class="line">355</span><br><span class="line">356</span><br><span class="line">357</span><br><span class="line">358</span><br><span class="line">359</span><br><span class="line">360</span><br><span class="line">361</span><br><span class="line">362</span><br><span class="line">363</span><br><span class="line">364</span><br><span class="line">365</span><br><span class="line">366</span><br><span class="line">367</span><br><span class="line">368</span><br><span class="line">369</span><br><span class="line">370</span><br><span class="line">371</span><br><span class="line">372</span><br><span class="line">373</span><br><span class="line">374</span><br><span class="line">375</span><br><span class="line">376</span><br><span class="line">377</span><br><span class="line">378</span><br><span class="line">379</span><br><span class="line">380</span><br><span class="line">381</span><br><span class="line">382</span><br><span class="line">383</span><br><span class="line">384</span><br><span class="line">385</span><br><span class="line">386</span><br><span class="line">387</span><br><span class="line">388</span><br><span class="line">389</span><br><span class="line">390</span><br><span class="line">391</span><br><span class="line">392</span><br><span class="line">393</span><br><span class="line">394</span><br><span class="line">395</span><br><span class="line">396</span><br><span class="line">397</span><br><span class="line">398</span><br><span class="line">399</span><br><span class="line">400</span><br><span class="line">401</span><br><span class="line">402</span><br><span class="line">403</span><br><span class="line">404</span><br><span class="line">405</span><br><span class="line">406</span><br><span class="line">407</span><br><span class="line">408</span><br><span class="line">409</span><br><span class="line">410</span><br><span class="line">411</span><br><span class="line">412</span><br><span class="line">413</span><br><span class="line">414</span><br><span class="line">415</span><br><span class="line">416</span><br><span class="line">417</span><br><span class="line">418</span><br><span class="line">419</span><br><span class="line">420</span><br><span class="line">421</span><br><span class="line">422</span><br><span class="line">423</span><br><span class="line">424</span><br><span class="line">425</span><br><span class="line">426</span><br><span class="line">427</span><br><span class="line">428</span><br><span class="line">429</span><br><span class="line">430</span><br><span class="line">431</span><br><span class="line">432</span><br><span class="line">433</span><br><span class="line">434</span><br><span class="line">435</span><br><span class="line">436</span><br><span class="line">437</span><br><span class="line">438</span><br><span class="line">439</span><br><span class="line">440</span><br><span class="line">441</span><br><span class="line">442</span><br><span class="line">443</span><br><span class="line">444</span><br><span class="line">445</span><br><span class="line">446</span><br><span class="line">447</span><br><span class="line">448</span><br><span class="line">449</span><br><span class="line">450</span><br><span class="line">451</span><br><span class="line">452</span><br><span class="line">453</span><br><span class="line">454</span><br><span class="line">455</span><br><span class="line">456</span><br><span class="line">457</span><br><span class="line">458</span><br><span class="line">459</span><br><span class="line">460</span><br><span class="line">461</span><br><span class="line">462</span><br><span class="line">463</span><br><span class="line">464</span><br><span class="line">465</span><br><span class="line">466</span><br><span class="line">467</span><br><span class="line">468</span><br><span class="line">469</span><br><span class="line">470</span><br><span class="line">471</span><br><span class="line">472</span><br><span class="line">473</span><br><span class="line">474</span><br><span class="line">475</span><br><span class="line">476</span><br><span class="line">477</span><br><span class="line">478</span><br><span class="line">479</span><br><span class="line">480</span><br><span class="line">481</span><br><span class="line">482</span><br><span class="line">483</span><br><span class="line">484</span><br><span class="line">485</span><br><span class="line">486</span><br><span class="line">487</span><br><span class="line">488</span><br><span class="line">489</span><br><span class="line">490</span><br><span class="line">491</span><br><span class="line">492</span><br><span class="line">493</span><br><span class="line">494</span><br><span class="line">495</span><br><span class="line">496</span><br><span class="line">497</span><br><span class="line">498</span><br><span class="line">499</span><br><span class="line">500</span><br><span class="line">501</span><br><span class="line">502</span><br><span class="line">503</span><br><span class="line">504</span><br><span class="line">505</span><br><span class="line">506</span><br><span class="line">507</span><br><span class="line">508</span><br><span class="line">509</span><br><span class="line">510</span><br><span class="line">511</span><br><span class="line">512</span><br><span class="line">513</span><br><span class="line">514</span><br><span class="line">515</span><br><span class="line">516</span><br><span class="line">517</span><br><span class="line">518</span><br><span class="line">519</span><br><span class="line">520</span><br><span class="line">521</span><br><span class="line">522</span><br><span class="line">523</span><br><span class="line">524</span><br><span class="line">525</span><br><span class="line">526</span><br><span class="line">527</span><br><span class="line">528</span><br><span class="line">529</span><br><span class="line">530</span><br><span class="line">531</span><br><span class="line">532</span><br><span class="line">533</span><br><span class="line">534</span><br><span class="line">535</span><br><span class="line">536</span><br><span class="line">537</span><br><span class="line">538</span><br><span class="line">539</span><br><span class="line">540</span><br><span class="line">541</span><br><span class="line">542</span><br><span class="line">543</span><br><span class="line">544</span><br><span class="line">545</span><br><span class="line">546</span><br><span class="line">547</span><br><span class="line">548</span><br><span class="line">549</span><br><span class="line">550</span><br><span class="line">551</span><br><span class="line">552</span><br><span class="line">553</span><br><span class="line">554</span><br><span class="line">555</span><br><span class="line">556</span><br><span class="line">557</span><br><span class="line">558</span><br><span class="line">559</span><br><span class="line">560</span><br><span class="line">561</span><br><span class="line">562</span><br><span class="line">563</span><br><span class="line">564</span><br><span class="line">565</span><br><span class="line">566</span><br><span class="line">567</span><br><span class="line">568</span><br><span class="line">569</span><br><span class="line">570</span><br><span class="line">571</span><br><span class="line">572</span><br><span class="line">573</span><br><span class="line">574</span><br><span class="line">575</span><br><span class="line">576</span><br><span class="line">577</span><br><span class="line">578</span><br><span class="line">579</span><br><span class="line">580</span><br><span class="line">581</span><br><span class="line">582</span><br><span class="line">583</span><br><span class="line">584</span><br><span class="line">585</span><br></pre></td><td class="code"><pre><span class="line"><span class="keyword">package</span> org;</span><br><span class="line"> </span><br><span class="line"> </span><br><span class="line"><span class="keyword">import</span> java.sql.Connection;</span><br><span class="line"><span class="keyword">import</span> java.sql.DriverManager;</span><br><span class="line"><span class="keyword">import</span> java.sql.PreparedStatement;</span><br><span class="line"><span class="keyword">import</span> java.sql.SQLException;</span><br><span class="line"><span class="keyword">import</span> java.util.Calendar;</span><br><span class="line"><span class="keyword">import</span> java.util.concurrent.atomic.AtomicInteger;</span><br><span class="line"> </span><br><span class="line"><span class="comment">/*</span></span><br><span class="line"><span class="comment">    测试同库不同表和不同库不同表的性能之间的差别</span></span><br><span class="line"><span class="comment"> */</span></span><br><span class="line"><span class="keyword">public</span> <span class="class"><span class="keyword">class</span> <span class="title">MainT</span> </span>&#123;</span><br><span class="line">    <span class="keyword">static</span> AtomicInteger atomicInteger = <span class="keyword">new</span> AtomicInteger(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">    <span class="keyword">static</span> <span class="class"><span class="keyword">class</span> <span class="title">ExecuteThread</span> <span class="keyword">extends</span> <span class="title">Thread</span> </span>&#123;</span><br><span class="line">        PreparedStatement preparedStatement;</span><br><span class="line">        Connection connection;</span><br><span class="line"> </span><br><span class="line">        <span class="function"><span class="keyword">public</span> <span class="title">ExecuteThread</span><span class="params">(PreparedStatement statement, Connection connection)</span> </span>&#123;</span><br><span class="line">            <span class="keyword">this</span>.preparedStatement = statement;</span><br><span class="line">            <span class="keyword">this</span>.connection = connection;</span><br><span class="line">        &#125;</span><br><span class="line"> </span><br><span class="line">        <span class="meta">@Override</span></span><br><span class="line">        <span class="function"><span class="keyword">public</span> <span class="keyword">void</span> <span class="title">run</span><span class="params">()</span> </span>&#123;</span><br><span class="line">            <span class="keyword">try</span> &#123;</span><br><span class="line">                preparedStatement.executeBatch();</span><br><span class="line">            &#125; <span class="keyword">catch</span> (SQLException e) &#123;</span><br><span class="line">                e.printStackTrace();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">try</span> &#123;</span><br><span class="line">                connection.commit();</span><br><span class="line">            &#125; <span class="keyword">catch</span> (SQLException e) &#123;</span><br><span class="line">                e.printStackTrace();</span><br><span class="line">            &#125;</span><br><span class="line">            atomicInteger.addAndGet(<span class="number">1</span>);</span><br><span class="line">        &#125;</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="keyword">static</span> &#123;</span><br><span class="line">        <span class="keyword">try</span> &#123;</span><br><span class="line">            Class.forName(<span class="string">"com.mysql.jdbc.Driver"</span>);</span><br><span class="line">        &#125; <span class="keyword">catch</span> (ClassNotFoundException e) &#123;</span><br><span class="line">            e.printStackTrace();</span><br><span class="line">        &#125;</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">int</span> times = <span class="number">1000000</span>;</span><br><span class="line"> </span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">main</span><span class="params">(String[] args)</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        method1();</span><br><span class="line">        method2();</span><br><span class="line">        method3();</span><br><span class="line">        <span class="comment">//method4();</span></span><br><span class="line">        <span class="comment">//method5();</span></span><br><span class="line">        <span class="comment">//method6();</span></span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">long</span> time = <span class="number">0</span>;</span><br><span class="line"> </span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">start</span><span class="params">()</span> </span>&#123;</span><br><span class="line">        time = Calendar.getInstance().getTimeInMillis();</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">end</span><span class="params">(String string)</span> </span>&#123;</span><br><span class="line">        System.out.println(string + <span class="string">" "</span> + <span class="string">"time is:"</span> + (Calendar.getInstance().getTimeInMillis() - time));</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">        同数据库 多练接 事务批处理</span></span><br><span class="line"><span class="comment">     */</span></span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">method1</span><span class="params">()</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        Connection con = DriverManager.getConnection(<span class="string">"jdbc:mysql://127.0.0.1:3306/TestOther?useServerPrepStmts=true&amp;cachePrepStmts=true&amp;rewriteBatchedStatements=true"</span>, <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        Connection con2 = DriverManager.getConnection(<span class="string">"jdbc:mysql://127.0.0.1:3306/TestOther?useServerPrepStmts=true&amp;cachePrepStmts=true&amp;rewriteBatchedStatements=true"</span>, <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        con.setAutoCommit(<span class="keyword">false</span>);</span><br><span class="line">        con2.setAutoCommit(<span class="keyword">false</span>);</span><br><span class="line">        PreparedStatement statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        PreparedStatement statement2 = con2.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con2).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"同数据库 多练接 事务批处理:增加"</span>);</span><br><span class="line">        statement = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">        statement2 = con2.prepareStatement(<span class="string">"update tbtwo SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con2).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">        end(<span class="string">"同数据库 多练接 事务批处理:修改"</span>);</span><br><span class="line">        statement = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">        statement2 = con2.prepareStatement(<span class="string">"delete FROM tbtwo where id=?"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con2).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"同数据库 多练接 事务批处理:删除"</span>);</span><br><span class="line">        statement.close();</span><br><span class="line">        statement2.close();</span><br><span class="line">        con.close();</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">            不同数据库 多练接 事务批处理</span></span><br><span class="line"><span class="comment">         */</span></span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">method2</span><span class="params">()</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        Connection con = DriverManager.getConnection(<span class="string">"jdbc:mysql://127.0.0.1:3306/TestOne?useServerPrepStmts=true&amp;cachePrepStmts=true&amp;rewriteBatchedStatements=true"</span>, <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        Connection con2 = DriverManager.getConnection(<span class="string">"jdbc:mysql://127.0.0.1:3306/TestTwo?useServerPrepStmts=true&amp;cachePrepStmts=true&amp;rewriteBatchedStatements=true"</span>, <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        con.setAutoCommit(<span class="keyword">false</span>);</span><br><span class="line">        con2.setAutoCommit(<span class="keyword">false</span>);</span><br><span class="line">        PreparedStatement statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        PreparedStatement statement2 = con2.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con2).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"不同数据库 多练接 事务批处理:增加"</span>);</span><br><span class="line">        statement = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">        statement2 = con2.prepareStatement(<span class="string">"update tbtwo SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con2).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">        end(<span class="string">"不同数据库 多练接 事务批处理:修改"</span>);</span><br><span class="line">        statement = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">        statement2 = con2.prepareStatement(<span class="string">"delete FROM tbtwo where id=?"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con2).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"不同数据库 多练接 事务批处理:删除"</span>);</span><br><span class="line">        statement.close();</span><br><span class="line">        statement2.close();</span><br><span class="line">        con.close();</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">     * 同数据库 单练接 事务批处理</span></span><br><span class="line"><span class="comment">	 */</span></span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">method3</span><span class="params">()</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        Connection con = DriverManager.getConnection(</span><br><span class="line">                <span class="string">"jdbc:mysql://127.0.0.1:3306/TestOther?useServerPrepStmts=true&amp;cachePrepStmts=true&amp;rewriteBatchedStatements=true"</span>,</span><br><span class="line">                <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        con.setAutoCommit(<span class="keyword">false</span>);</span><br><span class="line">        PreparedStatement statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        PreparedStatement statement2 = con.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"同数据库 单练接 事务批处理:增加"</span>);</span><br><span class="line">        statement = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">        statement2 = con.prepareStatement(<span class="string">"update tbtwo SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">        end(<span class="string">"同数据库 单练接 事务批处理:修改"</span>);</span><br><span class="line">        statement = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">        statement2 = con.prepareStatement(<span class="string">"delete FROM tbtwo where id=?"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement.addBatch();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                statement2.addBatch();</span><br><span class="line">            &#125;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">200000</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement.executeBatch();</span><br><span class="line">                statement2.executeBatch();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement, con).start();</span><br><span class="line">        <span class="keyword">new</span> ExecuteThread(statement2, con).start();</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == <span class="number">2</span>) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"同数据库 单练接 事务批处理:修改"</span>);</span><br><span class="line">        statement.close();</span><br><span class="line">        statement2.close();</span><br><span class="line">        con.close();</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">        不同数据库 单链接 事务批处理</span></span><br><span class="line"><span class="comment">     */</span></span><br><span class="line">    <span class="comment">//不存在</span></span><br><span class="line"> </span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">        不同数据库，多链接，非批处理</span></span><br><span class="line"><span class="comment">    */</span></span><br><span class="line">    <span class="keyword">static</span> <span class="class"><span class="keyword">class</span> <span class="title">ExecuteThread2</span> <span class="keyword">extends</span> <span class="title">Thread</span> </span>&#123;</span><br><span class="line">        <span class="keyword">public</span> PreparedStatement statement;</span><br><span class="line"> </span><br><span class="line">        <span class="function"><span class="keyword">public</span> <span class="title">ExecuteThread2</span><span class="params">(PreparedStatement statement)</span> </span>&#123;</span><br><span class="line">            <span class="keyword">this</span>.statement = statement;</span><br><span class="line">        &#125;</span><br><span class="line"> </span><br><span class="line">        <span class="meta">@Override</span></span><br><span class="line">        <span class="function"><span class="keyword">public</span> <span class="keyword">void</span> <span class="title">run</span><span class="params">()</span> </span>&#123;</span><br><span class="line">            <span class="keyword">try</span> &#123;</span><br><span class="line"> </span><br><span class="line">                <span class="keyword">this</span>.statement.execute();</span><br><span class="line">            &#125; <span class="keyword">catch</span> (SQLException e) &#123;</span><br><span class="line">                System.out.println(<span class="keyword">this</span>.statement);</span><br><span class="line">                e.printStackTrace();</span><br><span class="line">            &#125;</span><br><span class="line">            atomicInteger.addAndGet(<span class="number">1</span>);</span><br><span class="line">        &#125;</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">method4</span><span class="params">()</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        Connection con = DriverManager.getConnection(</span><br><span class="line">                <span class="string">"jdbc:mysql://127.0.0.1:3306/TestOne"</span>,</span><br><span class="line">                <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        Connection con2 = DriverManager.getConnection(</span><br><span class="line">                <span class="string">"jdbc:mysql://127.0.0.1:3306/TestTwo"</span>,</span><br><span class="line">                <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        PreparedStatement statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        PreparedStatement statement2 = con2.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con2.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">" 不同数据库，多链接，非批处理:增加"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con2.prepareStatement(<span class="string">"update tbtwo SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">        end(<span class="string">" 不同数据库，多链接，非批处理:修改"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con2.prepareStatement(<span class="string">"delete FROM tbtwo where id=?"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">" 不同数据库，多链接，非批处理:删除"</span>);</span><br><span class="line">        statement.close();</span><br><span class="line">        statement2.close();</span><br><span class="line">        con.close();</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">    *   同数据库 单链接 非批处理</span></span><br><span class="line"><span class="comment">    * */</span></span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">method5</span><span class="params">()</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        Connection con = DriverManager.getConnection(</span><br><span class="line">                <span class="string">"jdbc:mysql://127.0.0.1:3306/TestOne"</span>,</span><br><span class="line">                <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        PreparedStatement statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        PreparedStatement statement2 = con.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">" 同数据库 单链接 非批处理:增加"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">        end(<span class="string">" 同数据库 单链接 非批处理:修改"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">" 同数据库 单链接 非批处理:删除"</span>);</span><br><span class="line">        statement.close();</span><br><span class="line">        statement2.close();</span><br><span class="line">        con.close();</span><br><span class="line">    &#125;</span><br><span class="line"> </span><br><span class="line">    <span class="comment">/*</span></span><br><span class="line"><span class="comment">    *   同数据库 多链接 非批处理</span></span><br><span class="line"><span class="comment">    * */</span></span><br><span class="line">    <span class="function"><span class="keyword">public</span> <span class="keyword">static</span> <span class="keyword">void</span> <span class="title">method6</span><span class="params">()</span> <span class="keyword">throws</span> SQLException </span>&#123;</span><br><span class="line">        Connection con = DriverManager.getConnection(</span><br><span class="line">                <span class="string">"jdbc:mysql://127.0.0.1:3306/TestOther"</span>,</span><br><span class="line">                <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        Connection con2 = DriverManager.getConnection(</span><br><span class="line">                <span class="string">"jdbc:mysql://127.0.0.1:3306/TestOther"</span>,</span><br><span class="line">                <span class="string">"root"</span>, <span class="string">"14159265jkl"</span>);</span><br><span class="line">        PreparedStatement statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        PreparedStatement statement2 = con2.prepareStatement(<span class="string">"insert into tbtwo(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con2.prepareStatement(<span class="string">"insert into tbone(id,name,password) values(?,'a','b')"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"  同数据库 多链接 非批处理:增加"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con2.prepareStatement(<span class="string">"update tbone SET name='aa',password='bb' where id=?"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line"> </span><br><span class="line">        end(<span class="string">"  同数据库 多链接 非批处理:修改"</span>);</span><br><span class="line">        start();</span><br><span class="line">        <span class="keyword">for</span> (<span class="keyword">int</span> a = <span class="number">0</span>; a &lt; times; a++) &#123;</span><br><span class="line">            <span class="keyword">if</span> (a % <span class="number">2</span> == <span class="number">0</span>) &#123;</span><br><span class="line">                statement = con.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">                statement.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement).start();</span><br><span class="line">            &#125; <span class="keyword">else</span> &#123;</span><br><span class="line">                statement2 = con2.prepareStatement(<span class="string">"delete FROM tbone where id=?"</span>);</span><br><span class="line">                statement2.setInt(<span class="number">1</span>, a);</span><br><span class="line">                <span class="keyword">new</span> ExecuteThread2(statement2).start();</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        <span class="keyword">while</span> (<span class="keyword">true</span>) &#123;</span><br><span class="line">            <span class="keyword">if</span> (atomicInteger.getAndAdd(<span class="number">0</span>) == times) &#123;</span><br><span class="line">                <span class="keyword">break</span>;</span><br><span class="line">            &#125;</span><br><span class="line">        &#125;</span><br><span class="line">        atomicInteger.set(<span class="number">0</span>);</span><br><span class="line">        end(<span class="string">"  同数据库 多链接 非批处理:删除"</span>);</span><br><span class="line">        statement.close();</span><br><span class="line">        statement2.close();</span><br><span class="line">        con.close();</span><br><span class="line">    &#125;</span><br><span class="line">&#125;</span><br></pre></td></tr></table></figure>
<h3 id="测试样例和结果"><a href="#测试样例和结果" class="headerlink" title="测试样例和结果"></a>测试样例和结果</h3><table>
<thead>
<tr>
<th>组号</th>
<th>是否是同一个数据库</th>
<th>是否使用多个链接</th>
<th>是否使用批处理方法</th>
<th>1w（毫秒）</th>
<th>100w（毫秒）</th>
</tr>
</thead>
<tbody>
<tr>
<td>第一组</td>
<td>Y</td>
<td>N</td>
<td>N</td>
<td>添加 :42306，修改 :43521，删除 :44073</td>
<td>大于一小时</td>
</tr>
<tr>
<td>第二组</td>
<td>N</td>
<td>Y</td>
<td>N</td>
<td>添加 : 34137，修改 : 34215，删除 : 33698</td>
<td>大于一小时</td>
</tr>
<tr>
<td>第三组</td>
<td>Y</td>
<td>Y</td>
<td>N</td>
<td>添加 : 34511，修改 : 34060，删除 : 33970</td>
<td>大于一小时</td>
</tr>
<tr>
<td>第四组</td>
<td>Y</td>
<td>N</td>
<td>Y</td>
<td>添加 : 81，修改 : 724，删除 : 454</td>
<td>添加 : 9504，修改 : 78451，删除 : 46229</td>
</tr>
<tr>
<td>第五组</td>
<td>N</td>
<td>Y</td>
<td>Y</td>
<td>添加 : 70，修改 : 424，删除 : 276</td>
<td>添加 : 8953，修改 : 69865，删除 : 40738</td>
</tr>
<tr>
<td>第六组</td>
<td>Y</td>
<td>Y</td>
<td>Y</td>
<td>添加 :200，修改 : 595，删除 : 289</td>
<td>添加 : 6119，修改 : 78899，删除 : 47316</td>
</tr>
</tbody>
</table>
<h3 id="总结（结合专题二和专题三）"><a href="#总结（结合专题二和专题三）" class="headerlink" title="总结（结合专题二和专题三）"></a>总结（结合专题二和专题三）</h3><p>单库多链接在大数据量（100w）下性能优势明显，但是多库分表在新能区间上更优，分表相比教不分表性能更好</p>

      
    </div>
    
    
    

    

    

    

    <footer class="post-footer">
      

      
      
      

      
        <div class="post-nav">
          <div class="post-nav-next post-nav-item">
            
              <a href="/2018/10/09/linux mint等ubuntu系统全局字体不统一，楷体无法更换问题/" rel="next" title="">
                <i class="fa fa-chevron-left"></i> 
              </a>
            
          </div>

          <span class="post-nav-divider"></span>

          <div class="post-nav-prev post-nav-item">
            
              <a href="/2018/10/09/java-注解反射动态代理-反射/" rel="prev" title="">
                 <i class="fa fa-chevron-right"></i>
              </a>
            
          </div>
        </div>
      

      
      
    </footer>
  </div>
  
  
  
  </article>



    <div class="post-spread">
      
    </div>
  </div>


          </div>
          


          

  



        </div>
        
          
  
  <div class="sidebar-toggle">
    <div class="sidebar-toggle-line-wrap">
      <span class="sidebar-toggle-line sidebar-toggle-line-first"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-middle"></span>
      <span class="sidebar-toggle-line sidebar-toggle-line-last"></span>
    </div>
  </div>

  <aside id="sidebar" class="sidebar">
    
    <div class="sidebar-inner">

      

      
        <ul class="sidebar-nav motion-element">
          <li class="sidebar-nav-toc sidebar-nav-active" data-target="post-toc-wrap">
            文章目录
          </li>
          <li class="sidebar-nav-overview" data-target="site-overview-wrap">
            站点概览
          </li>
        </ul>
      

      <section class="site-overview-wrap sidebar-panel">
        <div class="site-overview">
          <div class="site-author motion-element" itemprop="author" itemscope itemtype="http://schema.org/Person">
            
              <p class="site-author-name" itemprop="name">kyssion</p>
              <p class="site-description motion-element" itemprop="description"></p>
          </div>

          <nav class="site-state motion-element">

            
              <div class="site-state-item site-state-posts">
              
                <a href="/archives/">
              
                  <span class="site-state-item-count">133</span>
                  <span class="site-state-item-name">日志</span>
                </a>
              </div>
            

            
              
              
              <div class="site-state-item site-state-categories">
                
                  <span class="site-state-item-count">3</span>
                  <span class="site-state-item-name">分类</span>
                
              </div>
            

            
              
              
              <div class="site-state-item site-state-tags">
                
                  <span class="site-state-item-count">2</span>
                  <span class="site-state-item-name">标签</span>
                
              </div>
            

          </nav>

          

          

          
          

          
          

          

        </div>
      </section>

      
      <!--noindex-->
        <section class="post-toc-wrap motion-element sidebar-panel sidebar-panel-active">
          <div class="post-toc">

            
              
            

            
              <div class="post-toc-content"><ol class="nav"><li class="nav-item nav-level-2"><a class="nav-link" href="#java-jdbc驱动使用详解（三）单机分库分表下的性能测试"><span class="nav-number">1.</span> <span class="nav-text">java-jdbc驱动使用详解（三）单机分库分表下的性能测试</span></a><ol class="nav-child"><li class="nav-item nav-level-3"><a class="nav-link" href="#测试代码"><span class="nav-number">1.1.</span> <span class="nav-text">测试代码</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#测试样例和结果"><span class="nav-number">1.2.</span> <span class="nav-text">测试样例和结果</span></a></li><li class="nav-item nav-level-3"><a class="nav-link" href="#总结（结合专题二和专题三）"><span class="nav-number">1.3.</span> <span class="nav-text">总结（结合专题二和专题三）</span></a></li></ol></li></ol></div>
            

          </div>
        </section>
      <!--/noindex-->
      

      

    </div>
  </aside>


        
      </div>
    </main>

    <footer id="footer" class="footer">
      <div class="footer-inner">
        <div class="copyright">&copy; <span itemprop="copyrightYear">2018</span>
  <span class="with-love">
    <i class="fa fa-user"></i>
  </span>
  <span class="author" itemprop="copyrightHolder">kyssion</span>

  
</div>


  <div class="powered-by">由 <a class="theme-link" target="_blank" href="https://hexo.io">Hexo</a> 强力驱动</div>



  <span class="post-meta-divider">|</span>



  <div class="theme-info">主题 &mdash; <a class="theme-link" target="_blank" href="https://github.com/iissnan/hexo-theme-next">NexT.Mist</a> v5.1.4</div>




        







        
      </div>
    </footer>

    
      <div class="back-to-top">
        <i class="fa fa-arrow-up"></i>
        
      </div>
    

    

  </div>

  

<script type="text/javascript">
  if (Object.prototype.toString.call(window.Promise) !== '[object Function]') {
    window.Promise = null;
  }
</script>









  












  
  
    <script type="text/javascript" src="/lib/jquery/index.js?v=2.1.3"></script>
  

  
  
    <script type="text/javascript" src="/lib/fastclick/lib/fastclick.min.js?v=1.0.6"></script>
  

  
  
    <script type="text/javascript" src="/lib/jquery_lazyload/jquery.lazyload.js?v=1.9.7"></script>
  

  
  
    <script type="text/javascript" src="/lib/velocity/velocity.min.js?v=1.2.1"></script>
  

  
  
    <script type="text/javascript" src="/lib/velocity/velocity.ui.min.js?v=1.2.1"></script>
  

  
  
    <script type="text/javascript" src="/lib/fancybox/source/jquery.fancybox.pack.js?v=2.1.5"></script>
  


  


  <script type="text/javascript" src="/js/src/utils.js?v=5.1.4"></script>

  <script type="text/javascript" src="/js/src/motion.js?v=5.1.4"></script>



  
  

  
  <script type="text/javascript" src="/js/src/scrollspy.js?v=5.1.4"></script>
<script type="text/javascript" src="/js/src/post-details.js?v=5.1.4"></script>



  


  <script type="text/javascript" src="/js/src/bootstrap.js?v=5.1.4"></script>



  


  




	





  





  












  





  

  

  

  
  

  

  

  

</body>
</html>
